Electricity Consumption Report

Prepared By: Zahiruddin Zahidanishah

Introduction

This report reports shows the electricity consumption and amount payable for a typical double storey house in urban city located in Selangor, Malaysia. This report consists of data from year 2014 to date. This report will shows the relation between the consumption and payment for the electricity usage every month and every year.

The details of the house inventory and areas are as describe belows.

**Assets Details**
	Items	Description
0	Type	Double Storey Terrace House
1	Land Area (sq.m)	121
2	Build Up Area (sq.m)	180
3	Bedrooms	4
4	Bathrooms	3
5	Lighting Pts.	22
6	Power Pts.	14
7	Fan Pts.	4
8	AC Pts.	3

Summary of Annual Electriciy Consumption
Year	Total Usage (kWh)	Total Amount (RM)	Electricity Rate (RM/kWh)	Ave. Usage (kWh)	Ave. Amount (RM)	Ave. Usage/P (kWh/p)	Ave. Usage/A (kWh/m2)	Max. Usage (kWh)	Max. Amount (RM)
2014	3645	964	0.26	303	80	60	1	350	102
2015	3569	899	0.25	297	74	59	1	405	103
2016	4498	1365	0.30	374	113	74	2	530	188
2017	4719	1491	0.32	393	124	78	2	448	153
2018	4640	1439	0.31	386	119	77	2	490	175
2019	4249	1278	0.30	354	106	70	1	444	151
2020	5080	1240	0.24	423	103	84	2	1221	164
2021	4596	1326	0.29	383	110	76	2	444	136
2022	1826	524	0.29	365	104	30	0	460	152

Detail of Consumption (kWh) and Amount (RM) for Every Years From 2014 to 2020

Monthly Electricity Usage (kWh)
Months	2014	2015	2016	2017	2018	2019	2020	2021	2022
Jan	261	254	246	427	342	370	355	322	359
Feb	288	347	399	390	455	444	314	378	323
Mac	348	276	530	448	426	399	350	378	384
Apr	263	309	465	441	419	373	350	361	460
May	350	301	494	361	490	413	350	357	300
Jun	324	273	342	393	315	285	1221	393	nan
Jul	346	405	305	339	357	366	368	361	nan
Aug	268	238	409	383	412	280	344	436	nan
Sep	292	295	336	399	389	348	360	396	nan
Oct	267	266	378	406	358	336	336	444	nan
Nov	301	321	286	405	368	323	391	404	nan
Dec	337	284	308	327	309	312	341	366	nan

Monthly Electricity Cost (RM)
Months	2014	2015	2016	2017	2018	2019	2020	2021	2022
Jan	64	62	59	143	99	113	107	80	102
Feb	71	87	120	123	149	151	86	112	84
Mac	102	69	188	153	142	130	104	112	115
Apr	65	82	162	150	138	116	96	103	153
May	103	78	177	108	175	137	89	101	71
Jun	89	68	99	125	79	72	164	119	nan
Jul	101	104	80	92	106	113	112	103	nan
Aug	66	56	125	120	135	70	100	122	nan
Sep	74	75	88	123	115	103	108	109	nan
Oct	66	66	117	132	107	97	83	137	nan
Nov	78	82	72	131	112	90	107	125	nan
Dec	86	72	78	91	82	84	85	106	nan

Monthly Electricity Rates (kWh/p)
Months	2014	2015	2016	2017	2018	2019	2020	2021	2022
Jan	52	51	49	85	68	74	71	64	72
Feb	58	69	80	78	91	89	63	76	65
Mac	70	55	106	90	85	80	70	76	77
Apr	53	62	93	88	84	75	70	72	92
May	70	60	99	72	98	83	70	71	60
Jun	65	55	68	79	63	57	244	79	nan
Jul	69	81	61	68	71	73	74	72	nan
Aug	54	48	82	77	82	56	69	87	nan
Sep	58	59	67	80	78	70	72	79	nan
Oct	53	53	76	81	72	67	67	89	nan
Nov	60	64	57	81	74	65	78	81	nan
Dec	67	57	62	65	62	62	68	73	nan

Note:

This report is prepared by Zahiruddin Zahidanishah. This report is only for educational purposed and shall not be used for any commercial purposed.
This report is prepared using open source application such as Jupyter Notebook, Python, Plotly, Pandas and etc.

Months	2014	2015	2016	2017	2018	2019	2020	2021	2022
Jan	64	62	59	143	99	113	107	80	102
Feb	71	87	120	123	149	151	86	112	84
Mac	102	69	188	153	142	130	104	112	115
Apr	65	82	162	150	138	116	96	103	153
May	103	78	177	108	175	137	89	101	71
Jun	89	68	99	125	79	72	164	119	nan
Jul	101	104	80	92	106	113	112	103	nan
Aug	66	56	125	120	135	70	100	122	nan
Sep	74	75	88	123	115	103	108	109	nan
Oct	66	66	117	132	107	97	83	137	nan
Nov	78	82	72	131	112	90	107	125	nan
Dec	86	72	78	91	82	84	85	106	nan

Months	2014	2015	2016	2017	2018	2019	2020	2021	2022
Jan	52	51	49	85	68	74	71	64	72
Feb	58	69	80	78	91	89	63	76	65
Mac	70	55	106	90	85	80	70	76	77
Apr	53	62	93	88	84	75	70	72	92
May	70	60	99	72	98	83	70	71	60
Jun	65	55	68	79	63	57	244	79	nan
Jul	69	81	61	68	71	73	74	72	nan
Aug	54	48	82	77	82	56	69	87	nan
Sep	58	59	67	80	78	70	72	79	nan
Oct	53	53	76	81	72	67	67	89	nan
Nov	60	64	57	81	74	65	78	81	nan
Dec	67	57	62	65	62	62	68	73	nan

Months	2014	2015	2016	2017	2018	2019	2020	2021	2022
Jan	64	62	59	143	99	113	107	80	102
Feb	71	87	120	123	149	151	86	112	84
Mac	102	69	188	153	142	130	104	112	115
Apr	65	82	162	150	138	116	96	103	153
May	103	78	177	108	175	137	89	101	71
Jun	89	68	99	125	79	72	164	119	nan
Jul	101	104	80	92	106	113	112	103	nan
Aug	66	56	125	120	135	70	100	122	nan
Sep	74	75	88	123	115	103	108	109	nan
Oct	66	66	117	132	107	97	83	137	nan
Nov	78	82	72	131	112	90	107	125	nan
Dec	86	72	78	91	82	84	85	106	nan

Months	2014	2015	2016	2017	2018	2019	2020	2021	2022
Jan	52	51	49	85	68	74	71	64	72
Feb	58	69	80	78	91	89	63	76	65
Mac	70	55	106	90	85	80	70	76	77
Apr	53	62	93	88	84	75	70	72	92
May	70	60	99	72	98	83	70	71	60
Jun	65	55	68	79	63	57	244	79	nan
Jul	69	81	61	68	71	73	74	72	nan
Aug	54	48	82	77	82	56	69	87	nan
Sep	58	59	67	80	78	70	72	79	nan
Oct	53	53	76	81	72	67	67	89	nan
Nov	60	64	57	81	74	65	78	81	nan
Dec	67	57	62	65	62	62	68	73	nan

Months	2014	2015	2016	2017	2018	2019	2020	2021	2022
Jan	64	62	59	143	99	113	107	80	102
Feb	71	87	120	123	149	151	86	112	84
Mac	102	69	188	153	142	130	104	112	115
Apr	65	82	162	150	138	116	96	103	153
May	103	78	177	108	175	137	89	101	71
Jun	89	68	99	125	79	72	164	119	nan
Jul	101	104	80	92	106	113	112	103	nan
Aug	66	56	125	120	135	70	100	122	nan
Sep	74	75	88	123	115	103	108	109	nan
Oct	66	66	117	132	107	97	83	137	nan
Nov	78	82	72	131	112	90	107	125	nan
Dec	86	72	78	91	82	84	85	106	nan

Months	2014	2015	2016	2017	2018	2019	2020	2021	2022
Jan	52	51	49	85	68	74	71	64	72
Feb	58	69	80	78	91	89	63	76	65
Mac	70	55	106	90	85	80	70	76	77
Apr	53	62	93	88	84	75	70	72	92
May	70	60	99	72	98	83	70	71	60
Jun	65	55	68	79	63	57	244	79	nan
Jul	69	81	61	68	71	73	74	72	nan
Aug	54	48	82	77	82	56	69	87	nan
Sep	58	59	67	80	78	70	72	79	nan
Oct	53	53	76	81	72	67	67	89	nan
Nov	60	64	57	81	74	65	78	81	nan
Dec	67	57	62	65	62	62	68	73	nan